inherited FrmInventario: TFrmInventario
  Left = 309
  Top = 211
  Caption = 'Relat'#243'rio de Invent'#225'rio'
  ClientHeight = 356
  OldCreateOrder = True
  PixelsPerInch = 96
  TextHeight = 13
  inherited pnlOpcoes: TPanel
    Height = 271
    object Label3: TLabel
      Left = 14
      Top = 10
      Width = 73
      Height = 13
      Caption = 'Data Invent'#225'rio'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = []
      ParentFont = False
    end
    object Label1: TLabel
      Left = 14
      Top = 49
      Width = 41
      Height = 13
      Caption = 'Empresa'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = []
      ParentFont = False
    end
    object Label4: TLabel
      Left = 14
      Top = 93
      Width = 31
      Height = 13
      Caption = 'Se'#231#227'o'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = []
      ParentFont = False
    end
    object Label6: TLabel
      Left = 14
      Top = 136
      Width = 30
      Height = 13
      Caption = 'Marca'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = []
      ParentFont = False
    end
    object LblProduto: TLabel
      Left = 14
      Top = 178
      Width = 37
      Height = 13
      Caption = 'Produto'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = []
      ParentFont = False
    end
    object Label2: TLabel
      Left = 14
      Top = 223
      Width = 67
      Height = 13
      Caption = 'Tipo de Pre'#231'o'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = []
      ParentFont = False
    end
    object LblSaldo: TLabel
      Left = 189
      Top = 223
      Width = 27
      Height = 13
      Caption = 'Saldo'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = []
      ParentFont = False
    end
    object EdtDataInicial: TEdit
      Left = 14
      Top = 23
      Width = 90
      Height = 21
      Hint = 
        'Digite a data sem barras. Ex: Voc'#234' digita 010101 e a data fica (' +
        '01/01/01)'
      CharCase = ecUpperCase
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = []
      ParentFont = False
      ParentShowHint = False
      ShowHint = True
      TabOrder = 0
      OnExit = EdtDataInicialExit
    end
    object EditEmpresa: TEdit
      Left = 14
      Top = 62
      Width = 49
      Height = 21
      Hint = 'C'#243'digo da empresa'
      ParentShowHint = False
      ShowHint = True
      TabOrder = 1
      OnExit = EditEmpresaExit
    end
    object BtnEmpresa: TBitBtn
      Left = 66
      Top = 62
      Width = 22
      Height = 21
      Hint = 'Buscar empresa'
      Caption = '...'
      ParentShowHint = False
      ShowHint = True
      TabOrder = 2
      TabStop = False
      OnClick = BtnEmpresaClick
    end
    object EditSecao: TEdit
      Left = 14
      Top = 106
      Width = 49
      Height = 21
      Hint = 'C'#243'digo da se'#231#227'o'
      ParentShowHint = False
      ShowHint = True
      TabOrder = 3
      OnExit = EditSecaoExit
    end
    object BtnSecao: TBitBtn
      Left = 63
      Top = 106
      Width = 25
      Height = 21
      Hint = 'Buscar se'#231#227'o'
      Caption = '...'
      ParentShowHint = False
      ShowHint = True
      TabOrder = 4
      TabStop = False
      OnClick = BtnSecaoClick
    end
    object EditMarca: TEdit
      Left = 14
      Top = 149
      Width = 121
      Height = 21
      Hint = 'C'#243'digo da marca'
      ParentShowHint = False
      ShowHint = True
      TabOrder = 5
      OnExit = EditMarcaExit
    end
    object BtnMarca: TBitBtn
      Left = 136
      Top = 149
      Width = 23
      Height = 21
      Hint = 'Buscar marca'
      Caption = '...'
      ParentShowHint = False
      ShowHint = True
      TabOrder = 6
      TabStop = False
      OnClick = BtnMarcaClick
    end
    object BtnProduto: TBitBtn
      Left = 136
      Top = 191
      Width = 22
      Height = 21
      Hint = 'Buscar produto'
      Caption = '...'
      ParentShowHint = False
      ShowHint = True
      TabOrder = 8
      TabStop = False
      OnClick = BtnProdutoClick
    end
    object EditProduto: TEdit
      Left = 14
      Top = 191
      Width = 121
      Height = 21
      Hint = 'C'#243'digo do produto'
      ParentShowHint = False
      ShowHint = True
      TabOrder = 7
      OnExit = EditProdutoExit
    end
    object Cb_TipoPreco: TComboBox
      Left = 14
      Top = 236
      Width = 139
      Height = 21
      Hint = 'Tipo de pre'#231'o'
      Style = csDropDownList
      ItemHeight = 13
      ItemIndex = 1
      ParentShowHint = False
      ShowHint = True
      TabOrder = 9
      Text = 'CUSTO'
      OnChange = Cb_TipoPrecoChange
      Items.Strings = (
        'COMPRA'
        'CUSTO'
        'VENDA'
        'ATACADO')
    end
    object CB_Saldo: TComboBox
      Left = 190
      Top = 236
      Width = 145
      Height = 21
      Hint = 'Saldo'
      Style = csDropDownList
      ItemHeight = 13
      ItemIndex = 0
      ParentShowHint = False
      ShowHint = True
      TabOrder = 10
      Text = 'MAIOR QUE ZERO'
      Items.Strings = (
        'MAIOR QUE ZERO'
        'GERAL'
        'IGUAL A ZERO'
        'NEGATIVO')
    end
    object stEmpresa: TStaticText
      Left = 89
      Top = 62
      Width = 388
      Height = 21
      AutoSize = False
      BorderStyle = sbsSingle
      TabOrder = 11
    end
    object stSecao: TStaticText
      Left = 89
      Top = 106
      Width = 387
      Height = 21
      AutoSize = False
      BorderStyle = sbsSingle
      TabOrder = 12
    end
    object stMarca: TStaticText
      Left = 160
      Top = 149
      Width = 316
      Height = 21
      AutoSize = False
      BorderStyle = sbsSingle
      TabOrder = 13
    end
    object stProduto: TStaticText
      Left = 160
      Top = 191
      Width = 316
      Height = 21
      AutoSize = False
      BorderStyle = sbsSingle
      TabOrder = 14
    end
  end
  inherited pnlBotoes: TPanel
    Top = 312
  end
  inherited pnlCabecalho: TPanel
    Caption = 'Relat'#243'rio de Invent'#225'rio'
  end
  inherited RvProjectModelo: TRvProject
    Left = 120
    Top = 25
  end
  inherited sql_dataset_principal: TSQLClientDataSet
    CommandText = 
      'select EP.ESP_CODIGO, EP.ESP_DESCRI,'#13#10'       EP.ESP_REFERE, EP.U' +
      'NI_CODIGO,'#13#10'       ENP.ENP_PRECOCOMPRA AS VALOR, '#13#10'       ESS.ES' +
      'S_SALDO AS SALDO'#13#10'from ESTOQUE_PRODUTO EP'#13#10'left join SECAO SE   ' +
      '          on SE.SEC_CODIGO = EP.ESP_SECCOD'#13#10'left join MARCA MA  ' +
      '           on MA.MAR_CODIGO = EP.ESP_MARCOD'#13#10'left join ESTOQUE_E' +
      'MPRESA  EE  on EE.ESE_IDFCOD = EP.ESP_IDFCOD'#13#10'left join ESTOQUE_' +
      'SERIAL   ESS on ESS.ESS_IDFPRODUTO= EP.ESP_IDFCOD and ESS.ESS_SA' +
      'LDO > 0'#13#10'left join ENTRADA_SERIAL   ENS on ENS.ENS_SERIAL= ESS.E' +
      'SS_SERIAL'#13#10'left join ENTRADA_PRODUTOS ENP on ENP.ENP_IDFDOCUMENT' +
      'O=ENS.ENS_IDFDOCUMENTO AND ENP.ENP_SEQITEMDOCUM=ENS.ENS_IDFITEMD' +
      'OCUM'#13#10'where EP.ESP_ATIVO='#39'X'#39' ;'
    Left = 312
    Top = 161
    object sql_dataset_principalESP_CODIGO: TStringField
      FieldName = 'ESP_CODIGO'
      Required = True
      Size = 13
    end
    object sql_dataset_principalESP_DESCRI: TStringField
      FieldName = 'ESP_DESCRI'
      Required = True
      Size = 40
    end
    object sql_dataset_principalESP_REFERE: TStringField
      FieldName = 'ESP_REFERE'
    end
    object sql_dataset_principalVALOR: TFMTBCDField
      FieldName = 'VALOR'
      Precision = 15
      Size = 3
    end
    object sql_dataset_principalSALDO: TFMTBCDField
      FieldName = 'SALDO'
      Precision = 15
      Size = 3
    end
    object sql_dataset_principalTotal: TFloatField
      FieldKind = fkInternalCalc
      FieldName = 'Total'
    end
    object sql_dataset_principalUNI_CODIGO: TStringField
      FieldName = 'UNI_CODIGO'
      Required = True
      Size = 3
    end
  end
  inherited rds_dataset_principal: TRvDataSetConnection
    Top = 153
  end
  inherited RvSystemPDF: TRvSystem
    Left = 440
    Top = 9
  end
  object SQLC_InventarioProdutos_Tmp: TSQLClientDataSet
    CommandText = 
      'select EP.ESP_IDFCOD, EP.ESP_CODIGO, EP.ESP_CODBAR, EP.ESP_DESCR' +
      'I,'#13#10'       EP.ESP_UNIDAD, EP.ESP_SECCOD, SE.SEC_NOME, EP.ESP_MAR' +
      'COD,'#13#10'       MA.MAR_NOME, EP.ESP_CONTROLE, EE.ESE_SALDO, ESS.ESS' +
      '_SERIAL AS SERIAL,'#13#10'       EE.ESE_PREVEN, EE.ESE_PRECOM, EE.ESE_' +
      'PRECUS, EP.ESP_REFERE,'#13#10'       ENP.ENP_PRECOCOMPRA AS VALOR, ENP' +
      '.ENP_PRECOCUSTO ,'#13#10'       ENP.ENP_PRECOVENDA , ENP.ENP_PRECOATAC' +
      'ADO,'#13#10'       ESS.ESS_SALDO AS SALDO'#13#10'from ESTOQUE_PRODUTO EP'#13#10'le' +
      'ft join SECAO SE             on SE.SEC_CODIGO = EP.ESP_SECCOD'#13#10'l' +
      'eft join MARCA MA             on MA.MAR_CODIGO = EP.ESP_MARCOD'#13#10 +
      'left join ESTOQUE_EMPRESA  EE  on EE.ESE_IDFCOD = EP.ESP_IDFCOD'#13 +
      #10'left join ESTOQUE_SERIAL   ESS on ESS.ESS_IDFPRODUTO= EP.ESP_ID' +
      'FCOD and ESS.ESS_SALDO > 0'#13#10'left join ENTRADA_SERIAL   ENS on EN' +
      'S.ENS_SERIAL= ESS.ESS_SERIAL'#13#10'left join ENTRADA_PRODUTOS ENP on ' +
      'ENP.ENP_IDFDOCUMENTO=ENS.ENS_IDFDOCUMENTO AND ENP.ENP_SEQITEMDOC' +
      'UM=ENS.ENS_IDFITEMDOCUM'#13#10'where EP.ESP_ATIVO='#39'S'#39#13#10
    Aggregates = <>
    Options = [poAllowCommandText]
    ObjectView = True
    Params = <>
    DBConnection = DtmGeral.ConexaoBanco
    Left = 208
    Top = 72
  end
end
